Example: Find total number of pledges by amount
This query extracts the total number of members who have made a pledge of $50 or more.
- Browse to IQA.
- Select Query from the drop-down list and select New.
- Select your sources:
- Browse to the Common folder containing business objects.
- Select the business objects:
- Define the filtering rules:
- Select the Filters tab.
- Filter on Activity.Activity Type:
- Property: Activity.Activity Type
- Comparison: Equal
- Value: PLEDGE
- Add the filter.
- Filter on Activity.Amount:
- Property: Activity.Amount
- Comparison: Greater
- Value: 50
- Add the filter.
- Define the columns that display in the output:
- Select the Display tab.
- Mode: Advanced
- Property: Contact.iMIS Id
- Function: Count
- Alias: Pledges
- Order: 1
- Select the Display option.
Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.
- Save your settings.
- Run the query.